Tabela LumpSumContractDefinition

Definicja tabeli LumpSumContractDefinition

Name

LumpSumContractDefinition

Code

LumpSumContractDefinition

Comment

PL: definicja umów/produktów kontraktowych (ryczaltowych)


Lista kolumn tabeli LumpSumContractDefinition

Name

Code

ContractNo

ContractNo

Year

Year

Month

Month

StartDT

StartDT

StopDT

StopDT

ContractServCode

ContractServCode

ContractServDistinction

ContractServDistinction

ContractServName

ContractServName

OrgUnitCode

OrgUnitCode

OrgUnitName

OrgUnitName

Limit

Limit

LumpSum

LumpSum

Type

Type

Price

Price


Kolumna ContractNo tabeli LumpSumContractDefinition

Definicja kolumny ContractNo tabeli LumpSumContractDefinition

Name

ContractNo

Code

ContractNo

Data Type

VARCHAR2(50)

Mandatory

Yes

Comment

numer umowy


Kolumna Year tabeli LumpSumContractDefinition

Definicja kolumny Year tabeli LumpSumContractDefinition

Name

Year

Code

Year

Data Type

NUMBER(5)

Mandatory

No

Comment

rok produktu kontr.


Kolumna Month tabeli LumpSumContractDefinition

Definicja kolumny Month tabeli LumpSumContractDefinition

Name

Month

Code

Month

Data Type

NUMBER(3)

Mandatory

No

Comment

miesiac produktu kontr.


Kolumna StartDT tabeli LumpSumContractDefinition

Definicja kolumny StartDT tabeli LumpSumContractDefinition

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

data poczatku umowy


Kolumna StopDT tabeli LumpSumContractDefinition

Definicja kolumny StopDT tabeli LumpSumContractDefinition

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

data konca umowy


Kolumna ContractServCode tabeli LumpSumContractDefinition

Definicja kolumny ContractServCode tabeli LumpSumContractDefinition

Name

ContractServCode

Code

ContractServCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

kod produktu kontr.


Kolumna ContractServDistinction tabeli LumpSumContractDefinition

Definicja kolumny ContractServDistinction tabeli LumpSumContractDefinition

Name

ContractServDistinction

Code

ContractServDistinction

Data Type

NUMBER(10)

Mandatory

No

Comment

wyróznik


Kolumna ContractServName tabeli LumpSumContractDefinition

Definicja kolumny ContractServName tabeli LumpSumContractDefinition

Name

ContractServName

Code

ContractServName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

kod produktu jedn.


Kolumna OrgUnitCode tabeli LumpSumContractDefinition

Definicja kolumny OrgUnitCode tabeli LumpSumContractDefinition

Name

OrgUnitCode

Code

OrgUnitCode

Data Type

VARCHAR2(255)

Mandatory

No

Comment

kod jedn. wykonujacej


Kolumna OrgUnitName tabeli LumpSumContractDefinition

Definicja kolumny OrgUnitName tabeli LumpSumContractDefinition

Name

OrgUnitName

Code

OrgUnitName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

nazwa jedn. wykonujacej


Kolumna Limit tabeli LumpSumContractDefinition

Definicja kolumny Limit tabeli LumpSumContractDefinition

Name

Limit

Code

Limit

Data Type

NUMBER(14,4)

Mandatory

No

Comment

limit produktu kontr.


Kolumna LumpSum tabeli LumpSumContractDefinition

Definicja kolumny LumpSum tabeli LumpSumContractDefinition

Name

LumpSum

Code

LumpSum

Data Type

NUMBER(14,4)

Mandatory

No

Comment

wartosc ryczaltu umowy


Kolumna Type tabeli LumpSumContractDefinition

Definicja kolumny Type tabeli LumpSumContractDefinition

Name

Type

Code

Type

Data Type

VARCHAR2(2)

Mandatory

Yes

Comment

typ danych (ryczaltowe/nieryczaltowe), wartosc w postaci R lub N


Kolumna Price tabeli LumpSumContractDefinition

Definicja kolumny Price tabeli LumpSumContractDefinition

Name

Price

Code

Price

Data Type

NUMBER(14,4)

Mandatory

No

Comment

cena za punkt w modulach statystycznych